begin;

CREATE SEQUENCE _100351.brc_id_seq
    INCREMENT BY 1;

Create Table _100351.brc
(
brc_id integer DEFAULT nextval('_100351.brc_id_seq'::text) NOT NULL,
transaction_id character varying,
transaction_type character varying,
export_promotion character varying,
export_promotion_date date,
description character varying,
bill_of_lading character varying,
bill_of_lading_date date,
value1 numeric,
value2 numeric,
bill_amount numeric,
freight_amount numeric,
insurance_amount numeric,
commission_paid character varying,
convertable boolean,
fob_value numeric,
bank_ref_no character varying,
date_of_export date,
date_of_realization date,
form_no character varying,
category_id character varying,
sign_name character varying,
designation character varying
);

alter table certificate_of_origin_commercial add column invoice_no character varying ;
alter table certificate_of_origin_commercial add column invoice_date date;

commit;